As part of the merge process, the following actions are performed on all IDs that are merged or deleted:
|
Table |
Field(s) |
Updated to |
|
ContactMain |
SyncContactID |
NULL |
|
ContactMain |
ContactStatusCode |
3 (Delete) |
Additionally, if the merged or deleted ID had an associated user record, the following actions are performed:
|
Table |
Field(s) |
Updated to |
|
UserMain |
ContactMaster, UserId |
Empty |
|
UserMain |
IsDisabled |
1 (True) |
Tip: For optimal performance, purge unused users and contacts (see Purging user and contact records) using the DB Maintenance Utility after you have merged contact records.
Important:
DMM will not merge any data from .NET tables (other than ContactMain and UserMain). Merging contact records that have associated .NET records may result in orphaned records. Examples include (but not limited to):
■ DocumentMain.CreatedByUserKey
■ DocumentMain.UpdatedByUserKey
■ GroupMain.MemberContactKey
■ GroupMain.MemberContactKey